ADO.NET Reporting Node

This node, under Server Configuration in the Workflow Administration Console, lets you determine if the Workflow Server allows ADO.NET reporting and how many concurrent ADO.NET connections can be made to the Workflow database.

Show me this node. 

To open this node

1. In the Workflow Administration Console's Console Pane, expand the Server Configuration node.
2. Select ADO.NET Reporting. The center Details Pane will show the maximum number of connections allowed, if ADO.NET Reporting is enabled or disabled, and the user that authorized the connection with the Workflow database.

Tip: You can refresh this list to reflect recent changes by clicking the Refresh link below ADO.NET Reporting in the Actions Pane. Alternatively, right-click the ADO.NET Reporting node and select Refresh.

To configure ADO.NET Reporting

1. In the Console Pane, select the ADO.NET Reporting node.
2. Click Properties in the Actions Pane, or right-click and select Properties.
3. In the ADO Reporting dialog box,



• Select to Enable ADO Reporting, or clear this option to disable reporting.
• If you enabled ADO Reporting, enter the User name and Password of a Windows user who can connect to the Workflow database.
• If you enabled ADO Reporting, specify the maximum number of ADO.NET connections that can be made to the Workflow database. You can allow Unlimited connections or specify a limit to the number of ADO.NET connections that can be made to the database at one time.

To export the contents of this node in a .csv, .xml, or .txt file

1. Select the node in the Console Pane.
2. Select View from the main menu.
3. Click Export Contents.



4. In the Export data dialog box, name the exported file.
5. Select CSV File, XML File, or Tab Delimited Text File from the drop-down menu.
6. Click Save.